Release 10.1A: OpenEdge Reporting:
Query/Results for Windows

Using a Totals-Only Summary

In the Report and Export views, Totals-Only Summary provides a quick way to calculate and display the combined value of a column of data for a specific break group. See "Sorting records" section for more information.

Figure 6–14 shows a query that does not use Totals Only Summary. In this example, the query displays the orders for each customer. The query uses the Cust-Num field to sort the orders for each customer in ascending order. Thus, it contains one break group-a break group for customers.

Figure 6–14: Sort order by Cust-num field - example one

As Figure 6–15 shows, the query contains a break group based on the Cust-Num field. Therfore, you can use Totals Only Summary to calculate and display the combined value of the Extended-Price field for each set of customer orders.

Figure 6–15: Sort order by Totals Only Summary - example two

When you use Totals Only Summary, Results summarizes the information and displays one record for each group containing the total for the group. Note that when you use Totals Only Summary the Export view, Results displays the preceding records in the group in addition to the record containing the total.

To use Totals Only Summary:

Verify that you have at least one break group. If you have more than one break group, Total Only Summary automatically uses the break group based on the last field in your sort list to perform the total.
Choose Options Totals Only Summary. The Totals Only Summary dialog box appears:



Select one or more fields to total, then choose OK.